<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta content="Cask Data, Inc." name="author" />
<meta content="Copyright © 2015 Cask Data, Inc." name="copyright" />


    <meta name="git_release" content="6.1.1">
    <meta name="git_hash" content="05fbac36f9f7aadeb44f5728cea35136dbc243e5">
    <meta name="git_timestamp" content="2020-02-09 08:22:47 +0800">
    <title>Integrations</title>

    <link rel="stylesheet" href="_static/cdap-bootstrap.css" type="text/css" />
    <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
    <link rel="stylesheet" href="_static/bootstrap-3.3.6/css/bootstrap.min.css" type="text/css" />
    <link rel="stylesheet" href="_static/bootstrap-3.3.6/css/bootstrap-theme.min.css" type="text/css" />
    <link rel="stylesheet" href="_static/css/bootstrap-sphinx.css" type="text/css" />
    <link rel="stylesheet" href="_static/css/cdap-dynamicscrollspy-4.css" type="text/css" />
    <link rel="stylesheet" href="_static/css/jquery.mCustomScrollbar.css" type="text/css" />
    <link rel="stylesheet" href="_static/css/cdap-jquery.mCustomScrollbar.css" type="text/css" />
    <link rel="stylesheet" href="_static/css/abixTreeList-2.css" type="text/css" />
    <link rel="stylesheet" href="_static/cdap-bootstrap.css" type="text/css" />

    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    '',
        VERSION:     '6.1.1',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  false
      };
    </script>
    <script type="text/javascript" src="_static/jquery.js"></script>
    <script type="text/javascript" src="_static/underscore.js"></script>
    <script type="text/javascript" src="_static/doctools.js"></script>
    <script type="text/javascript" src="_static/language_data.js"></script>

    <link rel="shortcut icon" href="_static/favicon.ico"/>
    <link rel="index" title="Index" href="genindex.html" />
    <link rel="search" title="Search" href="search.html" />
    <link rel="top" title="Cask Data Application Platform 6.1.1 Documentation" href="#" />
    <link rel="next" title="Hub" href="hub.html" />
    <link rel="prev" title="CDAP 集成手册目录" href="table-of-contents.html" />
    <!-- block extrahead -->
    <meta charset='utf-8'>
    <meta http-equiv='X-UA-Compatible' content='IE=edge,chrome=1'>
    <meta name='viewport' content='width=device-width, initial-scale=1.0, maximum-scale=1'>
    <meta name="apple-mobile-web-app-capable" content="yes">
    <!-- block extrahead end -->

</head>
<body role="document">

<!-- block navbar -->
<div id="navbar" class="navbar navbar-inverse navbar-default navbar-fixed-top">
    <div class="container-fluid">
      <div class="row">
        <div class="navbar-header">
          <!-- .btn-navbar is used as the toggle for collapsed navbar content -->
          <a class="navbar-brand" href="table-of-contents/../../index.html">
            <span><img alt="CDAP logo" src="_static/cdap_logo.svg"/></span>
          </a>

          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".nav-collapse">
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>

          <div class="pull-right">
            <div class="dropdown version-dropdown">
              <a href="#" class="dropdown-toggle" data-toggle="dropdown"
                role="button" aria-haspopup="true" aria-expanded="false">
                v 6.1.1 <span class="caret"></span>
              </a>
              <ul class="dropdown-menu">
                <li><a href="//docs.cdap.io/cdap/5.1.2/en/index.html">v 5.1.2</a></li>
                <li><a href="//docs.cdap.io/cdap/4.3.4/en/index.html">v 4.3.4</a></li>
              </ul>
            </div>
          </div>
          <form class="navbar-form navbar-right navbar-search" action="search.html" method="get">
            <div class="form-group">
              <div class="navbar-search-image material-icons"></div>
              <input type="text" name="q" class="form-control" placeholder="  Search" />
            </div>
            <input type="hidden" name="check_keywords" value="yes" />
            <input type="hidden" name="area" value="default" />
          </form>

          <div class="collapse navbar-collapse nav-collapse navbar-right navbar-navigation">
            <ul class="nav navbar-nav"><li class="docsite-nav-tab-container"><a class="docsite-nav-tab-link " href="table-of-contents/../../index.html">简介</a></li><li class="docsite-nav-tab-container"><a class="docsite-nav-tab-link current" href="table-of-contents/../../guides.html">手册</a></li><li class="docsite-nav-tab-container"><a class="docsite-nav-tab-link " href="table-of-contents/../../reference-manual/index.html">参考</a></li><li class="docsite-nav-tab-container"><a class="docsite-nav-tab-link " href="table-of-contents/../../faqs/index.html">帮助</a></li>
            </ul>
          </div>

        </div>
      </div>
    </div>
  </div><!-- block navbar end -->
<!-- block main content -->
<div class="main-container container">
  <div class="row"><div class="col-md-2">
      <div id="sidebar" class="bs-sidenav scrollable-y-outside" role="complementary">
<!-- theme_manual: integrations -->
<!-- theme_manual_highlight: guides -->
<!-- sidebar_title_link: table-of-contents/../../guides.html -->

  <div role="note" aria-label="manuals links"><h3><a href="table-of-contents/../../guides.html">Guides</a></h3>

    <ul class="this-page-menu">
      <li class="toctree-l1"><a href="table-of-contents/../../user-guide/index.html" rel="nofollow">用户手册</a>
      </li>
      <li class="toctree-l1"><a href="table-of-contents/../../developer-manual/index.html" rel="nofollow">开发手册</a>
      </li>
      <li class="toctree-l1"><a href="table-of-contents/../../admin-manual/index.html" rel="nofollow">管理手册</a>
      </li>
      <li class="toctree-l1"><b><a href="table-of-contents/../../integrations/index.html" rel="nofollow">集成手册</a></b>
      <nav class="pagenav">
      <ul class="current">
<li class="toctree-l1 current"><a class="current reference internal" href="#"> Introduction</a></li>
<li class="toctree-l1"><a class="reference internal" href="hub.html"> Hub</a></li>
<li class="toctree-l1"><a class="reference internal" href="partners/cloudera/index.html"> Cloudera</a><ul>
<li class="toctree-l2"><a class="reference internal" href="partners/cloudera/ingesting.html"> Ingestion and Exploration</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="apache-sentry.html"> Apache Sentry</a></li>
<li class="toctree-l1"><a class="reference internal" href="apache-ranger.html"> Apache Ranger</a></li>
<li class="toctree-l1"><a class="reference internal" href="hadoop-kms.html"> Apache Hadoop KMS</a></li>
<li class="toctree-l1"><a class="reference internal" href="jdbc.html"> CDAP JDBC Driver</a></li>
<li class="toctree-l1"><a class="reference internal" href="odbc.html"> CDAP ODBC Driver</a></li>
<li class="toctree-l1"><a class="reference internal" href="pentaho.html"> Pentaho Data Integration</a></li>
<li class="toctree-l1"><a class="reference internal" href="squirrel.html"> SquirrelSQL</a></li>
</ul>
</nav>
      </li>
      <li class="toctree-l1"><a href="table-of-contents/../../examples-manual/index.html" rel="nofollow">最佳实践</a>
      </li>
    </ul>
  </div></div>
    </div><div class="col-md-8 content" id="main-content">
    
  <div class="section" id="integrations">
<span id="id1"></span><h1>Integrations<a class="headerlink" href="#integrations" title="Permalink to this headline">🔗</a></h1>
<p class="rubric">Hub</p>
<ul class="simple">
<li><a class="reference external" href="hub.html#overview"><strong>Overview:</strong></a> Summary of the <strong>Hub,</strong> a source for re-usable
applications, data, and code for CDAP users</li>
</ul>
<ul class="simple">
<li><a class="reference external" href="hub.html#api"><strong>API:</strong></a> Hub APIs used to create entities in a Hub</li>
</ul>
<ul class="simple">
<li><a class="reference external" href="hub.html#custom"><strong>Custom Hosting:</strong></a> Hosting your own custom Hub</li>
</ul>
<p class="rubric">Cloudera</p>
<ul class="simple">
<li><a class="reference external" href="partners/cloudera/index.html"><strong>Overview:</strong></a> Utilizing CDAP on <strong>Cloudera Enterprise Data Hub</strong></li>
</ul>
<ul class="simple">
<li><a class="reference external" href="../admin-manual/installation/cloudera.html"><strong>Configuring and Installing:</strong></a> Configuring and installing CDAP using <strong>Cloudera Manager</strong> <em>(管理手册)</em></li>
</ul>
<ul class="simple">
<li><a class="reference external" href="partners/cloudera/ingesting.html"><strong>Ingestion and Exploration:</strong></a> Ingesting and exploring data using <strong>Impala</strong></li>
</ul>
<p class="rubric">Ambari <em>(管理手册)</em></p>
<ul class="simple">
<li><a class="reference external" href="../admin-manual/installation/ambari.html"><strong>Configuring and Installing:</strong></a> Configuring and installing CDAP using <strong>Ambari</strong> <em>(管理手册)</em></li>
</ul>
<p class="rubric">MapR <em>(管理手册)</em></p>
<ul class="simple">
<li><a class="reference external" href="../admin-manual/installation/mapr.html"><strong>Configuring and Installing:</strong></a> Configuring and installing CDAP on <strong>MapR</strong> <em>(管理手册)</em></li>
</ul>
<p class="rubric">Apache Sentry</p>
<ul class="simple">
<li><a class="reference external" href="apache-sentry.html"><strong>Integrations:</strong></a> Configuring and integrating CDAP with <strong>Apache Sentry</strong></li>
</ul>
<p class="rubric">Apache Ranger</p>
<ul class="simple">
<li><a class="reference external" href="apache-sentry.html"><strong>Integrations:</strong></a> Configuring and integrating CDAP with <strong>Apache Ranger</strong></li>
</ul>
<p class="rubric">Apache Hadoop Key Management Server (KMS)</p>
<ul class="simple">
<li><a class="reference external" href="hadoop-kms.html"><strong>Integrations:</strong></a> Configuring and integrating CDAP with <strong>Apache Hadoop Key Management Service (KMS)</strong></li>
</ul>
<p class="rubric">Accessing CDAP Datasets through JDBC and ODBC</p>
<p>Many Business Intelligence tools can integrate with relational databases using JDBC or ODBC
drivers. They often include drivers to connect to standard databases such as MySQL or
PostgreSQL. Most tools allow the addition of non-standard JDBC drivers.</p>
<p>Two business intelligence tools—<a class="reference internal" href="squirrel.html#squirrel-integration"><span class="std std-ref">SquirrelSQL</span></a> and
<a class="reference internal" href="pentaho.html#pentaho-integration"><span class="std std-ref">Pentaho Data Integration</span></a>—are covered, explaining connecting
them to a running CDAP instance and interacting with CDAP datasets.</p>
<p>The example <span class="xref std std-ref">cdap-bi-guide</span> includes the use of Pentaho.</p>
<ul class="simple">
<li><a class="reference external" href="jdbc.html"><strong>CDAP JDBC Driver:</strong></a> A JDBC driver provided with CDAP to make <strong>integrations with external programs</strong>
and third-party BI (business intelligence) tools easier.</li>
</ul>
<ul class="simple">
<li><a class="reference external" href="odbc.html"><strong>CDAP ODBC Driver:</strong></a> An ODBC driver provided for CDAP to allow <strong>integration with external Windows programs</strong>.</li>
</ul>
<ul class="simple">
<li><a class="reference external" href="pentaho.html"><strong>Pentaho Data Integration:</strong></a> An advanced, open source <strong>business intelligence tool</strong> that can execute
transformations of data.</li>
</ul>
<ul class="simple">
<li><a class="reference external" href="squirrel.html"><strong>SquirrelSQL:</strong></a> A simple JDBC client which <strong>executes SQL queries</strong> against many different relational databases.</li>
</ul>
</div>

</div>
    <div class="col-md-2">
      <div id="right-sidebar" class="bs-sidenav scrollable-y" role="complementary">
        <div id="localtoc-scrollspy">
        </div>
      </div>
    </div></div>
</div>
<!-- block main content end -->
<!-- block footer -->
<footer class="footer">
      <div class="container">
        <div class="row">
          <div class="col-md-2 footer-left"><a title="CDAP 集成手册目录" href="table-of-contents.html" />Previous</a></div>
          <div class="col-md-8 footer-center"><a class="footer-tab-link" href="table-of-contents/../../reference-manual/licenses/index.html">Copyright</a> &copy; 2014-2020 Cask Data, Inc.&bull; <a class="footer-tab-link" href="//docs.cask.co/cdap/6.1.1/cdap-docs-6.1.1-web.zip" rel="nofollow">Download</a> an archive or
<a class="footer-tab-link" href="//docs.cask.co/cdap">switch the version</a> of the documentation
          </div>
          <div class="col-md-2 footer-right"><a title="Hub" href="hub.html" />Next</a></div>
        </div>
      </div>
    </footer>
<!-- block footer end -->
<script type="text/javascript" src="_static/bootstrap-3.3.6/js/bootstrap.min.js"></script><script type="text/javascript" src="_static/js/bootstrap-sphinx.js"></script><script type="text/javascript" src="_static/js/abixTreeList-2.js"></script><script type="text/javascript" src="_static/js/cdap-dynamicscrollspy-4.js"></script><script type="text/javascript" src="_static/js/cdap-version-menu.js"></script><script type="text/javascript" src="_static/js/copy-to-clipboard.js"></script><script type="text/javascript" src="_static/js/jquery.mousewheel.min.js"></script><script type="text/javascript" src="_static/js/jquery.mCustomScrollbar.js"></script><script type="text/javascript" src="_static/js/js.cookie.js"></script><script type="text/javascript" src="_static/js/tabbed-parsed-literal-0.2.js"></script><script type="text/javascript" src="_static/js/cdap-onload-javascript.js"></script><script type="text/javascript" src="_static/js/cdap-version-menu.js"></script>
    <script src="https://cdap.gitee.io/docs/cdap/json-versions.js"/></script>
  </body>
</html>